TYPE=VIEW
query=select `op`.`nid` AS `nid`,count(`op`.`nid`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from `coursebay`.`uc_order_products` `op` group by `op`.`nid` order by `op`.`nid`
md5=ac25b14d350291609f2015c8e3dc5031
updatable=0
algorithm=0
definer_user=solvedho
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-07-14 04:22:39
create-version=1
source=select `op`.`nid` AS `nid`,count(`op`.`nid`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from `uc_order_products` `op` group by `op`.`nid` order by `op`.`nid`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `op`.`nid` AS `nid`,count(`op`.`nid`) AS `order_count`,avg(`op`.`qty`) AS `avg_qty`,sum(`op`.`qty`) AS `sum_qty`,max(`op`.`qty`) AS `max_qty`,min(`op`.`qty`) AS `min_qty` from `coursebay`.`uc_order_products` `op` group by `op`.`nid` order by `op`.`nid`
